Unique Strict Registry entry

Specify whether unique checks should be performed on a column that has been defined as unique on the server (in the table schema itself or using a Unique Index Registry entry). By default all unique columns are checked for uniqueness. With this entry it is possible to override the uniqueness check.

By default, all columns configured as unique in the table schema (by the developer) or using the Unique Index Registry entry are checked for uniqueness whenever a value is entered in the associated field and focus leaves the field. Setting Unique Strict to false disables the uniqueness check, allowing the record to be saved with duplicate values in the unique columns.

The Unique Override Registry entry performs a similar function to the Unique Strict Registry entry, allowing users / groups to save a record that violates uniqueness. A major difference is that users with the Unique Override permission receive a warning message that the column or columns are normally required to be unique, and must confirm that they wish to save the record with duplicate value(s).

Note: The warning message that displays for users with the Unique Override permission is defined in a Unique Registry entry.

When the Unique Strict Registry entry is specified for a column, affected users are able to save duplicate records without receiving a warning message.

However, if a user has the Unique Override permission for a column and the Unique Strict Registry entry is specified for the same column, that user will still receive the warning message and will need to confirm that they wish to save the record with duplicate value(s).

Usage

This Registry entry can be assigned to users and groups:

Key User User Group Group Group Group
Key 1 User User Group Group Group Group
Key 2 user user group group Default Default
Key 3 Table Table Table Table Table Table
Key 4 table Default table Default table Default
Key 5 Unique Strict
Key 6 column
Value boolean
User user Table table Unique Strict column boolean
User user Table Default Unique Strict column boolean
Group group Table table Unique Strict column boolean
Group group Table Default Unique Strict column boolean
Group Default Table table Unique Strict column boolean
Group Default Table Default Unique Strict column boolean

where:

column

the back-end name of the column set to be unique in the table schema (by the developer) or by using the Unique Registry entry.

boolean

is either true (the column must be unique) or false (duplicate values may be entered in the column).

Note: If this entry is not present, a setting of true is assumed.

Example

This entry specifies that the StateFileNumberPart3 field may contain duplicate values:

Key Setting
Key 1 Group
Key 2 Default
Key 3 Table
Key 4 emarriages
Key 5 Unique Strict
Key 6 StateFileNumberPart3
Value false